<?php

CREATE TABLE `t_news` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(1024) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
);

CREATE TABLE `t_info` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `info` varchar(1024) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
);
CREATE TABLE `t_news` (
  `id` varchar(20) not null primary key,
  `title` varchar(1024) NOT NULL DEFAULT ''
);

alter table t_news add column `rootid` varchar(31) not null default '';

| t_news | CREATE TABLE `t_news` (
  `id` varchar(20) NOT NULL,
  `title` varchar(1024) NOT NULL DEFAULT '',
  `rootid` varchar(31) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |



